﻿CREATE TABLE [dbo].[Finance_RunningAccountCopy] (
    [Id]               INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [RId]              INT             NULL,
    [CreateDate]       DATETIME        NULL,
    [TradeDate]        NVARCHAR (50)   NULL,
    [Summary]          NVARCHAR (50)   NULL,
    [AccountsTypeId]   INT             NULL,
    [AccountsTypeName] NVARCHAR (50)   NULL,
    [PaymentTypeId]    INT             NULL,
    [PaymentTypeName]  NVARCHAR (50)   NULL,
    [BankId]           INT             NULL,
    [BankName]         NVARCHAR (50)   NULL,
    [Income]           DECIMAL (18, 2) NULL,
    [Outlay]           DECIMAL (18, 2) NULL,
    [UserName]         NVARCHAR (50)   NULL,
    [EName]            NVARCHAR (50)   NULL,
    [CompanyId]        INT             NULL,
    [Description]      NVARCHAR (200)  NULL,
    [BillNumber]       NVARCHAR (50)   NULL,
    CONSTRAINT [PK_Finance_RunningAccountCopy] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_Finance_RunningAccountCopy_CreateDate]
    ON [dbo].[Finance_RunningAccountCopy]([CreateDate] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Finance_RunningAccountCopy_RId]
    ON [dbo].[Finance_RunningAccountCopy]([RId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Finance_RunningAccountCopy_CompanyId]
    ON [dbo].[Finance_RunningAccountCopy]([CompanyId] ASC);

